| |
607 Search Results Found |
| 1 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 01:25 «»
By: LIPEKA
RMAN-00554 RMAN-04006
…~]$ cat .profile_19c
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/X11R6/bin
export LD_LIBRARY_PATH=/usr/…
|
| 2 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 15:16 «»
By: LIPEKA
Re: RMAN-00554 RMAN-04006
…
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
#######################################
# For Primay…
|
| 3 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 13:30 «»
By: LIPEKA
Re: RMAN-00554 RMAN-04006
…cle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 21 September 2022 09:03 «»
By: John Watson
Re: Calling shell scripts from dbms_scheduler
…root.sh calls some scripts in here,
/u01/app/oracle/product/19.0.0/dbhome_prod/network/install
Looking at them I see this:
oracle@DB-19C-OL8:[/u01/app/oracle/product/19.0.0/dbhome_prod/rdbms/install]$ grep ext *
config_filemap.sbs:# Note that the …
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 October 2022 04:57 «»
By: fixxxer
ORA-29005: The certificate is invalid
…DDENSERVER.com:8443/healthcheck',NULL,'file:/u01/app/oracle/wallet') from dual;
UTL_HTTP.REQUEST('HTTPS://HIDDENSERVER.COM:8443/HEALTHCHECK',NULL,'FILE:/
--------------------------------------------------------------------------------
{"status&…
|
| 6 |
Forum: Linux «»
Posted on: Tue, 06 September 2022 05:04 «»
By: db_senior
How restart Oracle Database with OL8 Server Reboot
…
[oracle@ ~]# cat /etc/oratab
ORCL:/u01/app/oracle/product/19c/dbhome_1:Y
#Oracle Version (Single Instance)
Oracle Database 19c Enterprise Edition Version 19.12.0.0.0
#OS Version
[oracle@ ~]$ cat /etc/os-release
NAME="Oracle Linux Server&…
|
| 7 |
Forum: Security «»
Posted on: Tue, 05 July 2022 05:18 «»
By: keenweng2001
Remove and Disable the HSM
…oracle@D1 admin]$ cat sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=HSM)(METHOD_DATA=(DIRECTORY=$ORACLE_BASE/admin/$ORACLE_SID/wallet/)))
sqlnet.allowed_logon_version=…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 22 June 2022 03:47 «»
By: fixxxer
orapki: add crt and key to wallet
…p;
BEGIN
UTL_HTTP.SET_WALLET ('file:/u01/app/oracle/wallet','password');
lo_req := UTL_HTTP.begin_request('https://appserver.com:8443/test');
lo_resp := UTL_HTTP.get_response(lo_req);
dbms_output.put_line(lo_resp.status_code…
|
| 9 |
Forum: Backup & Recovery «»
Posted on: Tue, 24 May 2022 13:58 «»
By: bwdavis59
10gR2 -> 19c
…387211105;
RUN
{
startup nomount pfile '/u01/app/oracle/.../initDB.ora';
restore controlfile from autobackup;
mount database;
restore database;
alter database open resetlogs;
}
exit
RMAN searches the recovery file destination dutifully …
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 21 December 2021 01:53 «»
By: vippysharma
Re: SENDGRID | Curl
…uot;}}';
begin
UTL_HTTP.set_wallet('file:/u01/app/oracle/admin/DBNAME/wallet', '******');
req := utl_http.begin_request(url, 'POST',NULL,NULL,'*.api.sendgrid.com');
utl_http.set_header(req, 'Authorization', 'Bearer ****************KEY…
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 December 2021 06:21 «»
By: vippysharma
Re: SENDGRID | Curl
…uot;}}';
begin
UTL_HTTP.set_wallet('file:/u01/app/oracle/admin/DBNAME/wallet', '******');
req := utl_http.begin_request(url, 'POST',NULL,NULL,'*.api.sendgrid.com');
utl_http.set_header(req, 'Authorization', 'Bearer ****************KEY…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 December 2021 05:21 «»
By: vippysharma
Re: SENDGRID | Curl
…R2(4000);
begin
UTL_HTTP.set_wallet('file:/u01/app/oracle/admin/DBNAME/wallet', '******');
begin
req := utl_http.begin_request(url, 'POST',NULL,NULL,'*.api.sendgrid.com');
utl_http.set_header(req, 'Authorization', 'Bearer ****************KEY…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 December 2021 03:32 «»
By: vippysharma
Re: ORA 12545 | UTL_HTTP
…let_acl.
5. EXEC UTL_HTTP.set_wallet('file:/u01/app/oracle/admin/DBName/wallet', '***WalletPwD**');
6. Now execute final SQL and https_Host (CN name) should be mandatory else error will be there.
select utl_http.request(url => 'https://api.…
|
| 14 |
Forum: Backup & Recovery «»
Posted on: Tue, 23 November 2021 16:27 «»
By: ismbah
Job RMAN_LEVEL1_S3.PROD failed.
…IBRARY=libosbws.so, SBT_PARMS=(OSB_WS_PFILE=/u01/app/oracle/product/11.2.0.4/db_1/dbs/osbwsPDOCSEU.ora)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
…
|
| 15 |
Forum: Server Utilities «»
Posted on: Wed, 02 June 2021 00:29 «»
By: bkbora
Re: Issue with sqlldr
… see any error.
Any recommendation will be appreciated.
is there any other place where we need to set the oracle_home. Please help.
oracle_home -> /u01/app/oracle/product/193000_client/
oracle_home -> /u01/app/oracle/product/193000_client…
|
| 16 |
Forum: Server Utilities «»
Posted on: Tue, 01 June 2021 10:58 «»
By: bkbora
Issue with sqlldr
…x/y/z to oracle_home
oracle_home -> /u01/app/oracle/product/193000_client/
softlink from path a/b/c to oracle_home
oracle_home -> /u01/app/oracle/product/193000_client/
.profile contains(note we have multiple .profile file but different …
|
| 17 |
Forum: Backup & Recovery «»
Posted on: Wed, 24 March 2021 11:32 «»
By: Ikebukuro
Incremental level backup 1 without level 0
…
input datafile file number=00010 name=/u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/orcl12c/orcl/users01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/…
|
| 18 |
Forum: Security «»
Posted on: Mon, 08 March 2021 13:55 «»
By: evoradba
wrong path for waltet TDE
…
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '/u01/app/oracle/admin/TESTORA1/wallet/'
And should have been this
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '/u01/app/oracle/admin/TESTORA2/wallet/'
does anyone know how to fix this?
thank you…
|
| 19 |
Forum: Linux «»
Posted on: Tue, 23 February 2021 09:10 «»
By: Pablo030781
Re: Missing Package: gcc-c++-3.4.6 (x86_64)
…it the error below appeared:
Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u01/app/oracle/product/11.2.0/db_1/network/lib/ins_net_client.mk'. See '/u01/app/oraInventory/logs/installActions2021-02-23_02-26-58PM.log' for details…
|
| 20 |
Forum: Linux «»
Posted on: Thu, 12 November 2020 19:28 «»
By: solution
How to set backup automatically?
… ORACLE_SID=mydborcl
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG='AMERICAN_AMERICA.AL32UTF8'
expdp adminuser/Mypassword@mydborcl schemas=adminuser directory=my_db1 dumpfile=adminuser_`…
|
| 21 |
Forum: Weblogic & Application Server «»
Posted on: Wed, 11 November 2020 20:10 «»
By: agomez
Re: Web logic Server does not start
…BASE/domains; export DOMAIN_HOME
JAVA_HOME=/u01/app/oracle/jdk1.8.0_144; export JAVA_HOME
/usr/local/bin/oraenv
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export …
|
| 22 |
Forum: RAC & Failsafe «»
Posted on: Sun, 25 October 2020 12:25 «»
By: SamuelJk
Re: Oracle RAC error (2 merged)
…the issue lies
[root@racdb2 ~]# cd /u01/app/12.2.0/grid/bin/
[root@racdb2 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. …
|
| 23 |
Forum: RAC & Failsafe «»
Posted on: Sun, 25 October 2020 07:23 «»
By: SamuelJk
Re: Oracle RAC error (2 merged)
…@racdb2 ~]# pwd
/root
[root@racdb2 ~]# cd /u01/app/12.2.0/grid/bin/
[root@racdb2 bin]# ./crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors.
[root@racdb2 bin]# ./…
|
| 24 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 August 2020 01:05 «»
By: dirish
Re: ORA-12170: TNS:Connect timeout occurred
…
# tnsnames.ora Network Configuration File: /u01/app/ora19c/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
primarydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))
(CONNECT_DATA…
|
| 25 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 August 2020 01:03 «»
By: dirish
Re: ORA-12170: TNS:Connect timeout occurred
…= primarydb)
(ORACLE_HOME = /u01/app/ora19c)
(SID_NAME = primarydb)
)
(SID_DESC =
(GLOBAL_DBNAME = standbydb)
(ORACLE_HOME = /u01/app/ora19c)
(SID_NAME = standbydb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(…
|
| 26 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 August 2020 00:58 «»
By: dirish
Re: ORA-12170: TNS:Connect timeout occurred
… rights reserved.
Used parameter files:
/u01/app/ora19c/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primarydb)(PORT = 1521)) (CONNECT_DATA = (SERVER…
|
| 27 |
Forum: Data Guard «»
Posted on: Tue, 04 August 2020 10:22 «»
By: keenweng2001
Re: Recover Physical Standby Database Error
…-----------------------
4 STANDBY /u01/app/oracle/oradata/uat/stndbyuat_01.log
5 STANDBY /u01/app/oracle/oradata/uat/stndbyuat_02.log
6 STANDBY /u01/app/oracle/oradata/uat/stndbyuat_03.log
7 STANDBY /u01/app/…
|
| 28 |
Forum: Data Guard «»
Posted on: Tue, 04 August 2020 03:23 «»
By: keenweng2001
Re: Recover Physical Standby Database Error
…terminated with error 328
Errors in file /u01/app/oracle/diag/rdbms/uat1/uat1/trace/uat1_pr00_25145.trc:
ORA-00328: archived log ends at change 174537997, need later change 174855353
ORA-00334: archived log: '/u03/uat1/arch/1_16609_887236966.arc'
…
|
| 29 |
Forum: Data Guard «»
Posted on: Tue, 04 August 2020 02:19 «»
By: keenweng2001
Recover Physical Standby Database Error
…_standby_manual/uat1/PG_standby_control.ctl /u01/app/oracle/oradata/uat1/control01.ctl
catalog start with '/u04/resync_standby_manual/uat1/';
recover database
archived log for thread 1 with sequence 146446 is already on disk as file /u03/uat1/…
|
| 30 |
Forum: Server Administration «»
Posted on: Mon, 25 May 2020 12:09 «»
By: janakors
Re: Ora-48181. no space left on the device
…and as the system messages saying that it /u01 then i shown that . now all other file system are not 100% full. u can trust that. u saw the alert log errors , so if u want to help here the is time. all other file system have free space so if you can point…
|
| 31 |
Forum: Server Administration «»
Posted on: Sun, 24 May 2020 15:58 «»
By: janakors
Re: Ora-48181. no space left on the device
…caught while writing to trace file "/u01/app/oracle/diag/rdbms/mygrid/mygrid12/trace/mygrid12_m000_210009.trc"
Error Messages: SVr4 Error: 28 : No space left on device
writing to the above trace file is disabled for now on
Error: Direct …
|
| 32 |
Forum: Server Administration «»
Posted on: Thu, 21 May 2020 02:45 «»
By: janakors
Re: Ora-48181. no space left on the device
message is as follows which is reapetd many times but currently this message is gone
May 20 14:08 xxxx ufs: [ID 845546 kern.Notice] NOTICE:alloc: /u01: file system full
|
| 33 |
Forum: Server Administration «»
Posted on: Wed, 20 May 2020 01:48 «»
By: John Watson
Re: Ora-48181. no space left on the device
Er.... Perhaps /u01 is full? What does df actually tell you?
|
| 34 |
Forum: Server Administration «»
Posted on: Wed, 20 May 2020 00:12 «»
By: janakors
Re: Ora-48181. no space left on the device
I have searched the error code on the internet and then check my operating sys messages. /var/adm/messages.0 . it says that /u01 is full
please reply
|
| 35 |
Forum: Server Administration «»
Posted on: Tue, 19 May 2020 15:39 «»
By: EdStevens
Re: Ora-48181. no space left on the device
How did you determine "the error is due to /u01 is full", when the error message itself is pointing to ASM: "Error: Direct connection failure with ASM"
|
| 36 |
Forum: Server Administration «»
Posted on: Tue, 19 May 2020 04:43 «»
By: janakors
Ora-48181. no space left on the device
…: op 0 state 0x0 (15055)
the error is due to /u01 is full but when apply df -ah so it still showing 88 GB available. the trace file located at
/u01/app/oracle/diag/asm/+asm/+ASM2/trace
what can be the reason? please guide
Regards…
|
| 37 |
Forum: Data Guard «»
Posted on: Mon, 27 April 2020 03:34 «»
By: alex.bhgbx
Recover standby after losing sync
… to be consistent
ORA-01110: data file 2: '/u01/oracle/oradata/stbmain/sysaux01.dbf'
When i do recover of this datafile, recover of database "broke"(it means that all tablespaces dbfs i need again rename because they're located in different …
|
| 38 |
Forum: Client Tools «»
Posted on: Sat, 28 March 2020 10:41 «»
By: Andrey_R
Client fails to connect to new DB server with "TNS-03505: Failed to resolve name"
… OFF
Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/MY_ORCALE_MACHINE/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION…
|
| 39 |
Forum: Server Administration «»
Posted on: Mon, 23 March 2020 04:32 «»
By: Andrey_R
Cannot see DBA_USERS with SYS in a new database
…oracle]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@MY_ORACLE_MACHINE oracle]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.1.0.2/dbhome
I do NOT have any instance running:
[oracle@MY_ORACLE_MACHINE oracle]$ ps -ef | grep pmon
oracle …
|
| 40 |
Forum: Backup & Recovery «»
Posted on: Fri, 06 March 2020 13:32 «»
By: yordan
Re: Help with backup
Actually there is a dbs folder in
\ASCP\RDBMS_TechStack\u01\app\orapc\product\PVWSC\102\appsutil\template
but is an empty folder...
|
Blog
Search
Help
Members
Register
Login
Home